Query Language

NOTE: Following text extracted from http://msdn.microsoft.com/en-us/library/ff394619.aspx.

To search for any word or phrase on a Web site, enter the word into the field and click Search to begin.

This section also contains the following topics.

• Rules for Formulating Queries
• Property Value Queries
• Property Restrictions Based on File Information
• Tips
• ActiveX Property Values

Rules for Formulating Queries

Follow these rules when formulating queries.

By default, multiple words have an "and" relationship. So, the search term calendar server returns pages that have both words.

- To find pages with either term, use the OR operator. For example, calendar OR server returns pages that have either word.

IMPORTANT: You must capitalize boolean operators, such as AND.

- To find pages with several terms in exact order with no intervening words, use quotes. For example, “calendar server” returns pages that have both terms in that order.

- To find pages that have one term without another, use the NOT operator. For example, For example, calendar NOT server returns pages that have calendar and do not have server.

- To find several terms close together, use NEAR. For example, treatment NEAR immunoglobulin finds pages with the word “treatment” near the word “immunoglobulin”

The NEAR operator is like AND because it finds pages that include both search words. However, the rank assigned by NEAR depends on the proximity of the search words. A page with search terms closer together has a higher rank than a page where they are farther apart.

NOTE: The NEAR operator can be applied only to words or phrases.

Search terms are case-insensitive.

Punctuation marks, such as period (.) and comma (,), are ignored by the search.

Operators (<, >, and &) are ignored by a search. Also, the search does not find text within angle brackets, for example <Ektron>.

To include in a query special characters that are not operators, such as +, |, ^, #, @, $, (,), enclose the query in quotation marks (“).

Use the wildcard character (*) to find words that start with a certain letter sequence. For example, esc* returns Web pages with “ESC,” “escape,” etc.

Your can restrict search results by content properties (for example, filetype:gif returns all .gif images). See Also: Property Restrictions Based on File Information

You can search on ActiveX™ file properties. See Also: ActiveX Property Values

Tips

To nest expressions within a query, add parentheses. Expressions within parentheses are evaluated before the rest of the query.

Use double quotes (“) to ignore a boolean or NEAR operator keyword. For example, “Abbott and Costello” finds pages with the entire phrase, not pages that match the Boolean expression.

The AND operator has a higher precedence than OR. For example, the first three queries are equal, but the fourth is not:

- a AND b OR c

- c OR a AND b

- c OR (a AND b)

- (c OR a) AND b

Property Value Queries

Use property restrictions to find content whose values match a given criteria. Properties that can be queried include:

file information (name, size, author, etc.)

ActiveX Property Values, including the document summary stored in files created by ActiveX-aware applications.

Property Restrictions Based on File Information

Ektron's search supports several property operators. The table below lists samples of property restrictions that you can use.

To Search for	Example	Results
A specific text value	cmsauthor:Bill Diaz NOTE: To identify an author, enter a username, first name, or last name following the colon (:)	Content authored by Bill Diaz
	filename:Meeting notes.pdf	The file named Meeting notes.pdf
	filetype:gif	Content with a .gif extension
	taxonomycategory:Atrium	All content assigned to a taxonomy category named atrium
Values beginning with a prefix	Ektr*	Content that includes a word beginning with Ektr
	cmsauthor:Bi*	Content whose author begins with Bi
Property values in relation to a fixed value	size<100 size<=100 size=100 size>=100 size>100	Content whose size in kilobytes matches the query
	contentid>30	Content whose ID number is greater than 30
	contentid=30	Content whose ID number is 30
	folderid>250	All content in folders whose ID is greater than 250
	folderid=14	All content in the folder whose id is 14

Tips for Using Property Queries

You can combine queries. For example, cmsauthor:admin filetype:jpg returns .jpg files which were last edited by a user whose username is admin.

You can only use property restrictions for crawled properties that are mapped to a managed property. You can determine eligible properties by logging into the Sharepoint 2010 Central Administration panel and going to Central Administration > Search Service Application > Metadata Property Mappings.

ActiveX Property Values

You can also use ActiveX property values in queries. You can search for files created by most ActiveX-aware applications by querying for the following properties.

Property Name	Description
DocTitle	Title of the document
DocSubject	Subject of the document
DocAuthor	The document’s author
DocKeywords	Keywords for the document
DocComments	Comments about the document